### About
This repository includes files to prepare the data for the paper titled as The Impact of School Opening Model on SARS-CoV-2 Community Incidence and Mortality: A Nationwide Cohort Study by Ertem et al. 

### Installation
These scripts uses `Python 3.7.3` and the packages in `requirements.txt`.

To install necessary packages, from your terminal run:

`pip install -r requirements.txt`

### Usage

There are 4 scripst in the form of [Jupyter notebooks](https://ipython.org/) that prepares the data used for this paper.

1. Step 1 prepare_burbio_data_daily
    - This script assumes that
2. Step 2 Aggregate Burbio data to weekly
    - Similarly, this script also assumes the availability of the data from [Burbio](https://info.burbio.com/) about school opening.
3. Step 3 Combine Burbio with Mobility, Oxford data
    - This script combines the Burbio data with [Google mobility data](https://www.google.com/covid19/mobility/) and [Oxford Government Response Tracker data](https://github.com/OxCGRT/covid-policy-tracker).
4. Step 4 Prepare Age based case counts using CDC Restricted Data
    - This script assumes the availability of [COVID-19 Case Surveillance Restricted Access Detailed Data](https://data.cdc.gov/Case-Surveillance/COVID-19-Case-Surveillance-Restricted-Access-Detai/mbd7-r32t) .

Please run these scripts in order to create the final data that is used for the models in the paper.
